AWR Shared Pool Statistics

% SQL with executions>1: Shows % of SQLs executed more than 1 time. The % should be very near to value 100.


% memory for SQL w/exec>1: From the memory space allocated to cursors, shows which % has been used by cursors more than 1.

The ratio above 80% is always healthy.